Source database permissions

To generate the model by discovering the source database in the Replicate task, you need to define a connection to the source database used in the Replicate task. The user defined in the Source database connection settings must be granted the following permissions:

• Read metadata (Columns, Primary Keys and Foreign Keys)
• Select from tables

For more information, see Source Database Connection.